SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 20
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:HUGE PRICE REDUCTION! Abundant Sunshine fills this 2017 Colonial situated on 1.75 acres offering 4 bedrooms, open concept layout, sunshine galore makes your living space bright and inviting, gleaming hardwood floors, convenient 1st floor living w/laundry, 3/4 bath & bedroom, 2nd floor offers 3 bedrooms, a full bath and great closet space everywhere. The attached oversized 2 car garage flows seamlessly into the heated entry room with abundant storage affording ease with the comings and goings that your busy day entails. The lower level is impressive with it's high ceilings, easy expansion possibilities, Buderus propane boiler and spray foamed for add'l heat efficiency. The detached barn screams quintessential New England and offers two levels for game room, "toy" storage, third car garage or hey, why not rent the bay for seasonal storage and extra income. All this and a commuters dream! A hop & a skip to Mascoma Lake and only 1 mile to I-89 for easy access to Dartmouth Hitchcock Hospital and all Upper Valley Amenities.
Description:PRICE JUST IMPROVED!! OPEN HOUSE SATURDAY 4/26/25 10-12n Step into history at The Treetops, an extraordinary 4-bedroom, 2-bath home that was once part of the original Saint-Gaudens estate. This stunning property carries the spirit of the famed Cornish Art Colony, where master sculptor Augustus Saint-Gaudens and his creative circle found inspiration in the rolling hills of New Hampshire. Perched on a scenic private lot, this home offers a tranquil retreat surrounded by nature. A gentle stream winds through the property, adding to the peaceful ambiance, while garden spaces provide the perfect setting for cultivating beauty—just as artists once did in this very landscape. From the sun-drenched rooms to the charming historic details, The Treetops is a timeless escape that seamlessly blends past and present. Located just minutes from the Upper Valley, with easy access to both sides of the Connecticut River, this home offers the perfect balance of seclusion and convenience—close to Dartmouth College, world-class healthcare, vibrant arts, and year-round outdoor recreation. This is more than just a home; it's a living piece of history in one of New Hampshire’s most picturesque and storied communities. Opportunities like this are rare—don’t miss your chance to own a legacy!
Description:Ideal Hanover location! Less than 10 minutes to Dartmouth's campus, Dartmouth Health, and all of the fantastic amenities both Hanover and Lebanon have to offer. Fully renovated in 2018, this warm and inviting 2 bedroom, 2 bathroom home offers the ease of low maintenance condominium-like living, without the HOA fees. The main floor includes a spacious, vaulted ceiling living/dining area that opens to the kitchen (fully equipped with stainless steel appliances and soapstone countertops), bedroom/office, full bathroom, and laundry. On the second floor you'll find a large, loft-style, primary en-suite bedroom with an oversized closet. Renovation upgrades include, but are not limited to: windows, flooring, heating system, kitchen, baths and insulation. The full, unfinished basement and attached exterior shed offer ample storage space. During the warmer months, enjoy entertaining on the deck while overlooking lovely views of the Vermont mountains. Icing on the cake - despite it's wonderful, private setting, it's still on town sewer! Furnishings are digitally staged.
Description:Charming 2-bedroom Bungalow, thoughtfully updated, and ideally located near Dartmouth Hitchcock Medical Center and downtown Hanover. This home is perfect for those seeking a low-maintenance lifestyle with a small footprint, offering the benefits of single-family living. Situated in a desirable Hanover neighborhood, you'll enjoy your own backyard space featuring a firepit and a small patio, perfect for outdoor dining in the summer. A small back deck provides space for a grill, while a lovely three-season room overlooks the yard. Inside, the beautifully updated kitchen boasts cherry countertops, plenty of storage, a farmhouse sink, and a two-seat peninsula bar. The open living and dining area flow seamlessly from the kitchen, and there are two comfortable bedrooms and a tastefully appointed full bath. The basement offers versatile space for storage, utilities, a workbench, and laundry, plus room for one small car to park. It's been spray foamed for improved energy efficiency. This home has served as both a full-time residence and a reliable source of rental income for the owners over the years. Showings begin Saturday, April 19th at the open house 9:30am-12pm.
Description:Post Pond Possibilities!! One of a small number of lots that have pond access. Don't miss the opportunity to be a Post Pond resident. Camp/Cottage with rustic character overlooks the pond in a wooded setting. Most of the land already in current use and building envelope is ready for your personal touches. Septic installed new in 2007 with power and a drilled well onsite. Outbuildings for boat storage and more. Come and imagine life on the pond minutes from Hanover, Dartmouth College, and DHMC. All the amenities of the Upper Valley minutes away from your quiet access to nature and wooded serenity.